﻿<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
    <!--DXMETADATA start type="MetaCharset" --><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=UTF-8"><!--DXMETADATA end-->
    <meta http-equiv="X-UA-Compatible" value="IE=9" />

    <!--DXMETADATA start type="Literal" condition="helpversion:value=3" value="<meta name=""Microsoft.Help.SelfBranded"" content=""true"" />" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<title>%%ProjectTitle%% - %%ItemTitle%%</title>" --><title>SpreadJS Documentation - Stock Chart</title><!--DXMETADATA end-->
    <!--DXMETADATA start type="ItemTitle" format="<meta name=""Title"" content=""%%ProjectTitle%% - %%ItemTitleNoQuotes%%""/>" --><meta name="Title" content="SpreadJS Documentation - Stock Chart"/><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="jquery" filetype="script" firstlinkattributes="id=""mshs_support_script"""--><script src="template/packages/jquery/script/default/jquery-1.11.3.min.js" type="text/javascript" id="mshs_support_script"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="script"--><script src="template/packages/jquery-ui/script/default/jquery-ui-1.11.4.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="jquery-ui" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/jquery-ui/css/default/jquery-ui-1.11.4.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="TemplateSettingsJson" format="<script type=""text/javascript"">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:%%TemplateSettingsJson%%});</script>" --><script type="text/javascript">var Innovasys=(Innovasys||{});$.extend(true,Innovasys,{settings:{isHideBodyDuringLoadDisabled:true,dynamictoc:{isEnabled:true},inthistopic:{isSupported:true},dynamicstyles:{isDynamicWordWrapEnabled:true}}},{settings:{"dynamictoc":{"initialNodeId":"n373","initialNodeContainer":"c0","isResizable":true},"inthistopic":{"isEnabled":true},"currentLocale":"-","isFrameless":true,"navigationKind":"inpage","versions":{"locale":{"currentId":"-"}}}});</script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="light" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/light/css/dynamic-toc.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="Synopsis" StripHtmlTags="True" MaxLength="250" format="<meta name=""Description"" content=""%%Synopsis%%"" />"--><meta name="Description" content="An Stock chart is extensively used to illustrate fluctuations in the data. It can represent fluctuations for stock, daily rainfall, or annual temperatures. Typically, this chart is ideal for analysing financial data and visualizing stock information." /><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="css"--><link rel="stylesheet" type="text/css" href="template/packages/plugins-topics/css/default/jquery-plugins.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="css" firstlinkattributes=" data-mshv2-stylesheet=""/template/packages/core-topics/topics.mshv2.css"" data-mshv1-stylesheet=""/template/packages/core-topics/topics.mshv1.css"" data-responsive-mobile=""template/packages/core-topics/topics.mobile.css"" data-responsive-tablet=""template/packages/core-topics/topics.tablet.css"""--><link rel="stylesheet" type="text/css" href="template/packages/core-topics/css/topics.css"  data-mshv2-stylesheet="/template/packages/core-topics/topics.mshv2.css" data-mshv1-stylesheet="/template/packages/core-topics/topics.mshv1.css" data-responsive-mobile="template/packages/core-topics/topics.mobile.css" data-responsive-tablet="template/packages/core-topics/topics.tablet.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="plugins-topics" filetype="script"--><script src="template/packages/plugins-topics/script/default/jquery-plugins.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    <!--DXMETADATA start type="PackageLink" packagename="core-topics" filetype="script"--><script src="template/packages/core-topics/script/topics.min.js" type="text/javascript"></script><!--DXMETADATA end-->
    
    <!--DXMETADATA start type="TopicId" format="<meta name=""Microsoft.Help.Id"" content=""%%TopicId%%""/>" --><meta name="Microsoft.Help.Id" content="d31efab8-583b-47bf-90de-fe1ac7fd1f89"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocParentId" format="<meta name=""Microsoft.Help.TocParent"" content=""%%TocParentId%%""/>" --><meta name="Microsoft.Help.TocParent" content="1124f6de-499a-4032-8d2a-c338ec23d096"/><!--DXMETADATA end-->
    <!--DXMETADATA start type="TocOrdinal" format="<meta name=""Microsoft.Help.TocOrder"" content=""%%TocOrdinal%%""/>" --><meta name="Microsoft.Help.TocOrder" content="7"/><!--DXMETADATA end-->
    <meta name="Microsoft.Help.F1" content=""/>
    <meta name="Microsoft.Help.ContentType" content="Concepts" />
    <!--DXMETADATA start type="MshvKeywords" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="MshvMetaTags" condition="helpversion:value=3" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.Locale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Help3CatalogLocale" condition="helpversion:value=3" format="<meta name=""Microsoft.Help.TopicLocale"" content=""%%Help3CatalogLocale%%"" />"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Stylesheets" --><link rel="stylesheet" type="text/css" href="stylesheets/hs-simpletab.css"></link><!--DXMETADATA end-->
    <!--DXMETADATA start type="StylePropertyValues" format="<style>%%StylePropertyValues%%</style>" --><style>.i-is-new .i-page-title-text::after, ul#i-dt-root li.i-is-new>a::after { content: "New" }
</style><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scripts" --><!--DXMETADATA end-->
    <!--DXMETADATA start type="DesignTime"--><!--DXMETADATA end-->
    <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_PROPERTIES" --><!--DXMETADATA end -->
    <!--DXMETADATA start type="CustomHeadContent" --><link rel="stylesheet" type="text/css" href="template/packages/core-web/css/SP.css">
<script type="text/javascript">
var currentHeader = function() {
    return "spjs";
}
</script>
<script src="template/packages/core-web/script/topNavigation.js"></script>
<script async="" src="https://www.googletagmanager.com/gtm.js?id=GTM-WT462SJ"></script>
<script>
        (function (w, d, s, l, i) {
            w[l] = w[l] || [];
            w[l].push({
                'gtm.start': new Date().getTime()
                , event: 'gtm.js'
            });
            var f = d.getElementsByTagName(s)[0]
                , j = d.createElement(s)
                , dl = l != 'dataLayer' ? '&l=' + l : '';
            j.async = true;
            j.src = 'https://www.googletagmanager.com/gtm.js?id=' + i + dl;
            f.parentNode.insertBefore(j, f);
        })(window, document, 'script', 'dataLayer', 'GTM-WT462SJ');
    </script>
<!--DXMETADATA end-->
</head>

<body>
    <div id="i-before-header-content" class="i-before-header-content">
        
    </div>

    <div id="i-header-container">
        <div id="i-header-content" class="i-header-content i-content-width-container">
            <!--DXMETADATA start type="LogoImage" --><!--DXMETADATA end-->
            <div class="i-project-title"><!--DXMETADATA start type="ProjectTitle" -->SpreadJS Documentation<!--DXMETADATA end--></div>
            <div class="i-search-container">
                <!--DXMETADATA start type="outputfileextension" format="<form action=""websearch%%outputfileextension%%"">" --><form action="websearch.html"><!--DXMETADATA end-->
                <input id="i-search" name="query"/>
                <input type="submit" id="i-search-button" value=""/>
                <!--DXMETADATA start type="Literal" value="</form>" --></form><!--DXMETADATA end-->
            </div>
            <!--DXMETADATA start type="outputfileextension" format="<a id=""i-index-button"" href=""webindex%%outputfileextension%%""></a>" --><a id="i-index-button" href="webindex.html"></a><!--DXMETADATA end-->
        </div>
    </div>
    
    <div class="i-content-width-container"><div class="i-busy-overlay"></div></div>

    <div id="i-breadcrumbs-outer-container" class="i-content-width-container"><!--DXMETADATA start type="Breadcrumbs" scrap="_BREADCRUMBS" --><div class="i-breadcrumbs-container">
<a href="overview.html">SpreadJS Documentation</a>
 / <a href="devguide.html">Developer's Guide</a>
 / <a href="features.html">Features</a>
 / <a href="ManagingDataVisualizationAndObjects.html">Manage Data Visualization and Objects</a>
 / <a href="Charts.html">Charts</a>
 / <a href="ChartTypes.html">Chart Types</a>
 / Stock Chart</div><!--DXMETADATA end --></div>

    

    <div id="i-actions-outer-container" class="i-content-width-container">
        <div id="i-actions-container">
            <div id="i-actions-content" class="i-fixed-to-top">
                <!-- Spacing --> <span class="i-toggle-all-sections i-function-link">
                <label class="i-collapse-all"><!--DXMETADATA start type="Phrase" name="COLLAPSE_ALL" -->Collapse All<!--DXMETADATA end--></label>
                <label class="i-expand-all" style="display: none;"><!--DXMETADATA start type="Phrase" name="EXPAND_ALL" -->Expand All<!--DXMETADATA end--></label>
            </span><!--DXMETADATA start type="Literal" condition="communityenabled" value="%%scrap:name=_COMMUNITY_DROPDOWN%%" --><!--DXMETADATA end -->
                <div class="i-in-this-topic-container">
                    <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
                </div>
            </div>
        </div>
    </div>

    <div id="i-toc-outer-container" class="i-content-width-container">
        <div id="i-toc-container">
            <div id="i-toc-content" class="i-fixed-to-top">
                <div class="i-toc-content-scroll-container">
                    <div id="i-dynamic-toc-container"><ul id="i-dt-root"></ul></div>
                </div>
            </div>
        </div>
    </div>

    <div id="i-body-content-container" class="i-content-width-container">
        <div id="i-body-content" class="i-body-content">
            <div class="i-page-title"><div class="i-page-title-text"><!--DXMETADATA start type="ItemTitle" -->Stock Chart<!--DXMETADATA end--></div></div>
            <div class="i-in-this-topic-container">
                <span class="i-action-group-heading"><!--DXMETADATA start type="Phrase" Name="IN_THIS_TOPIC" -->In This Topic<!--DXMETADATA end--></span>
            </div>
            <!--DXMETADATA start type="TopicSection" name="BodyText"--><p>An Stock chart is extensively used to illustrate fluctuations in the data. It can represent fluctuations for stock, daily rainfall, or annual temperatures. Typically, this chart is ideal for analysing financial data and visualizing stock information.</p>

<p>The data arranged in columns or rows&nbsp;of&nbsp;a worksheet can be plotted in a Stock chart.</p>

<p>SpreadJS supports the following types of Stock charts. In the examples shown below, the market data anlysis at different time intervals is depicted with the help of different types of stock charts.</p>

<ol>
    <li>&nbsp;<strong>High-Low-Close</strong>

        <p>A high-low-close chart displays the data values organized in the order : 1) high, 2) low, 3) close with the close value lying&nbsp;in between the high and low values.</p>

        <p>An image of a high-low-close chart is shown below:<br />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img border="0" alt="" src="images/high-low-close.png" /></p>
    </li>

    <li>
        <strong>Open-High-Low-Close</strong>

        <p>An open-high-low-close chart displays the data values organized in the order : 1) open, 2) high, 3) low and then 4) close.</p>

        <p>An image of a open-high-low-close chart is shown below:<br />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img border="0" alt="" src="images/open-high-low-close.png" /></p>
    </li>

    <li>
        <strong>Volume-High-Low-Close</strong>

        <p>A volume-high-low-close chart displays the data values organized in the order : 1) volume, 2) high, 3) low and then 4) close.</p>

        <p>An image of&nbsp;a&nbsp;volume-high-low-close chart&nbsp;is shown below:<br />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img border="0" alt="" src="images/volume-high-low-close.png" /></p>
    </li>

    <li>
        <strong>Volume-</strong><strong>Open-High-Low-Close</strong>

        <p>A volume-open-high-low-close chart displays the data values organized in the order : 1) volume, 2) open, 3) high, 4) low and then 5) close.</p>

        <p>An image of&nbsp;a&nbsp;volume-open-high-low-close chart&nbsp;is shown below:<br />
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<img border="0" alt="" src="images/volume-open-high-low-close.png" /></p>
    </li>
</ol>

<h4>Using Code</h4>

<p>This code shows how to add different types of stock charts in a spreadsheet.</p>

<div class="i-filtered-content-JavaScript" data-title="JavaScript" data-itemid="JavaScript">
    <table class="i-syntax-table">
        <tbody>
            <tr>
                <th>JavaScript</th>

                <th>
                    <div class="i-copy-code-wrapper">
                        <span class="i-copy-code">Copy Code</span>
                    </div>
                </th>
            </tr>

            <tr>
                <td class="i-code" colspan="2">
                    <p class="i-dropdown-heading">Click here to see code.</p>

                    <div class="i-dropdown-content">
                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">data = dataSource;</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">function</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">initSpread(spread) {</font></font></font></font></font></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">spread.suspendPaint();</font></font></font></font></font></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">spread.options.tabStripRatio = 0.7;</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">chartTypeStr = [</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'stockHLC'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">,</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'stockOHLC'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">,</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'stockVHLC'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">,</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'stockVOHLC'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">];</font></font></font></font></font></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">chartType = [{</font></font></font></font></font></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">type: GC.Spread.Sheets.Charts.ChartType.stockHLC,</font></font></font></font></font></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">desc: chartTypeStr[0],</font></font></font></font></font></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}, {</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">type: GC.Spread.Sheets.Charts.ChartType.stockOHLC,</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">desc: chartTypeStr[1],</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}, {</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">type: GC.Spread.Sheets.Charts.ChartType.stockVHLC,</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">desc: chartTypeStr[2],</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}, {</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">type: GC.Spread.Sheets.Charts.ChartType.stockVOHLC,</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">desc: chartTypeStr[3],</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}];</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">sheets = SpreadJS;</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">sheet = sheets[sheets.length - 1];</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.suspendPaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.name(chartTypeStr[chartTypeStr.length - 1]);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setArray(0, 0, data);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.getRange(0, 0, 61, 1).formatter(</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'dd/mm/yyyy'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setColumnWidth(0, 80);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.resumePaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">initStockHLCChartSheetData(sheets[0], chartTypeStr[0]);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">initStockOHLCChartSheetData(sheets[1], chartTypeStr[1]);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">initStockVHLCChartSheetData(sheets[2], chartTypeStr[2]);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">for</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">(</font></font><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">i = 0; i &lt; chartType.length; i++) {</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet = sheets[i];</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">initChart(sheet, chartType[i].type, i);</font></font><font color="green" size="2" face="Consolas"><font color="green" size="2" face="Consolas"><font color="green" size="2" face="Consolas">//add chart</font></font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">spread.resumePaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">function</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">initStockHLCChartSheetData(sheet, sheetName) {</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.name(sheetName);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.suspendPaint();</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">formula =</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">"='stockVOHLC'!"</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">;</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">for</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">(</font></font><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">i = 0; i &lt; data.length - 1; i++) {</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 0, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'D'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 1, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'E'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 2, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'F'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 3, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.getRange(0, 0, 61, 1).formatter(</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'dd/mm/yyyy'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setColumnWidth(0, 80);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.resumePaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">function</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">initStockOHLCChartSheetData(sheet, sheetName) {</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.name(sheetName);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.suspendPaint();</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">formula =</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">"='stockVOHLC'!"</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">;</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">for</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">(</font></font><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">i = 0; i &lt; data.length - 1; i++) {</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 0, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'C'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 1, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'D'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 2, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'E'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 3, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'F'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 4, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.getRange(0, 0, 61, 1).formatter(</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'dd/mm/yyyy'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setColumnWidth(0, 80);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.resumePaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">function</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">initStockVHLCChartSheetData(sheet, sheetName) {</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.name(sheetName);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.suspendPaint();</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">formula =</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">"='stockVOHLC'!"</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">;</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">for</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">(</font></font><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">i = 0; i &lt; data.length - 1; i++) {</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 0, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'B'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 1, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'D'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 2, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'E'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 3, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">formula1 = formula +</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'f'</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">+ (i + 1);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setFormula(i, 4, formula1);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.getRange(0, 0, 61, 1).formatter(</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'dd/mm/yyyy'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.setColumnWidth(0, 80);</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.resumePaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">function</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">initChart(sheet, chartType, index) {</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.suspendPaint();</font></font></font></font></font></p>

                        <p></p>

                        <p>&nbsp;</p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">rangeIndex = [</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A1:D61'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">,</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A1:E61'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">,</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A1:E61'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">,</font></font> <font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'A1:F61'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">];</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="green" size="2" face="Consolas"><font color="green" size="2" face="Consolas"><font color="green" size="2" face="Consolas">//add chart</font></font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas">var</font></font></font> <font size="2" face="Consolas"><font size="2" face="Consolas">chart = sheet.charts.add(</font></font><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas"><font color="#A31515" size="2" face="Consolas">'Chart1'</font></font></font><font size="2" face="Consolas"><font size="2" face="Consolas">, chartType, 270, 60, 615, 270, rangeIndex[index]);</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">sheet.resumePaint();</font></font></font></font></font></p>

                        <p></p>

                        <p><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font color="blue" size="2" face="Consolas"><font size="2" face="Consolas"><font size="2" face="Consolas">}</font></font></font></font></font></p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>

                        <p>&nbsp;</p>
                    </div>
                </td>
            </tr>
        </tbody>
    </table>
</div><!--DXMETADATA end-->
            <a name="seealsobookmark"></a>
            <!--DXMETADATA start type="FilteredItemList" scrap="CATEGORISED_LINKS" namespace="linkcategory" source="Item" filter="" NoHeader="True" NoFooter="True" format="%%replaceinquotes:value=false%%%%scrap:name=_COLLAPSIBLE_HEADER,idprefix=seealso,caption=""%%phrase:name=SeeAlso%%%%designlist:tagidentifier=seealso,itemtype=See Also%%""%%%%filtereditemlist%%</div>"--><!--DXMETADATA end-->
            
            <div id="i-footer-content" class="i-footer-content">
                <!--DXMETADATA start type="Scrap" condition="communityenabled" name="_COMMUNITY_FOOTER" --><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="CopyrightNotice" format="<p>&nbsp;</p><p>&nbsp;</p><hr style=""height: 1px"" /><p>%%variable%%</p>" --><p>&nbsp;</p><p>&nbsp;</p><hr style="height: 1px" /><p><p>Copyright © 2019 GrapeCity, Inc. All rights reserved.</p>
<p><a href="https://www.grapecity.com/en/forums/winforms-edition" target="_blank">Product Support Forum</a> | <a href="javascript:window.print()">Print this page</a></p>
<ul class="social">
<li><a href="https://www.facebook.com/GrapeCityUS/" target="_blank" class="facebook">&nbsp;</a></li>
<li><a href="https://twitter.com/GrapeCityUS" target="_blank" class="twitter">&nbsp;</a></li>
<li><a href="https://www.linkedin.com/company/grapecity" target="_blank" class="linkedin">&nbsp;</a></li>
</ul>
</p><!--DXMETADATA end -->
<!--DXMETADATA start type="Variable" name="FeedbackLink" format="" --><!--DXMETADATA end-->
            </div>
        </div>
    </div>
        
    <script type="text/javascript">
        $(function () {
            var documentInstance = new Innovasys.Content.Document(document.body);
            documentInstance.load();
        });
    </script>
</body>
</html>
